SQL: The Ultimate Beginner's Guide to Learn SQL Programming Step by Step by Turner Ryan

Author:Turner, Ryan [Turner, Ryan]
Language: eng
Format: epub
Published: 2019-05-22T16:00:00+00:00

ALTER DATABASE DatabaseName SET RECOVERY BULK_LOGGED

Let’s say you’re in the middle of a large database project and need to back up the database. Use SQL syntax (and the examples above) to set the recovery model for Company_Db to “Full” to prepare for the backup process.

Database Backup Methods

There are a few main backup methods that can be used to back up databases in SQL Server, and each one is dependent on the recovery model being used. In the previous section regarding recovery models, the last bullet point in each model discussed the types of backups that can be performed, i.e. full, differential and transaction log.

Not e : if you don’t remember the types of backups that can be performed for each recovery model, just give yourself time! Eventually, you will remember them !

Each backup method will perform the following action:

Full:

Backs up the database in its entirety, as well as the transaction log (if applicable.)

Ideal if the same database needs to be added to a new server for testing.

It may take a longer period of time to back up if the database is large in size, in addition to it backing up the entire database and transaction log.

However, this doesn’t need to be performed nearly as often as a differential since you’re backing up the entire database.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.